SQL查询前两个数值是字母的列,比如TC0001,TC0002,0056,3396,48454...答:)AND (ASCII(SUBSTR(NUM,2,1)) >=97 and ASCII(SUBSTR(NUM,2,1))<=122 OR ASCII(SUBSTR(NUM,2,1)) between 65 and 90)分别判断第一位和第二位的ASCII码,65-90是大写的A-Z, 97-122是小写的a-z 以上SUBSTR是ORACLE函数,如果SQLSERVER,请用SUBSTRING DB2字符串截取的函数也是SUBSTR ...
db2 表数据分区 是否可以修改答:GRANT SELECT, INSERT, UPDATE, ALTER, DELETE, INDEX, REFERENCES ON TABLE "MABAS"."BAS_MID_TRANS_LIST_CK_BAK" TO USER "DB2INST2" WITH GRANT OPTION;GRANT SELECT, INSERT, UPDATE, ALTER, DELETE, INDEX, REFERENCES ON TABLE "MABAS"."BAS_MID_TRANS_LIST_CK_BAK" TO USER "D...
reorg到底需要多少表空间答:db2 "select substr(tabname,1,20),Npages,Fpages,card from syscat.tables order by Npages desc fetch first 10 rows only"临时表空间预留最大nleaf的量,最大的nleaf*表空间页大小,最大的索引对应的nleaf可通过以下sql获得 db2 "select substr(tabname,1,20),substr(indname,1,18),nleaf,in...